SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154531,833739,783538,1024006,799400,989738,786166,554698,733034,894488,745859,921316,278867,1031584,342602,471203,214018,873882,1000627,365191,854288,665774,253735,220294,276503,1029256,561316,452610,372922,290361,178386,317759,222868,893195,794699,312633,905330,752926,410670,83008,52839,461416,5388,645704,974791,798000,342863,1004065,232080,970450,982822,60243,19960,243536,172960,469162,295385,270567,717999,1038027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]