SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538096 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538096 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306609,813512,1029873,430974,172006,741265,719125,549208,885409,539951,166017,28600,311044,561505,661214,210012,168708,854979,380782,137386,844337,409750,663737,430099,781590,843332,952336,547209,619785,394147,747381,196428,418504,541509,557027,574664,165890,553317,1034620,625242,831228,879510,678992,711587,1038768,689777,464561,516294,371388,803819,278440,943878,180366,710829,1041008,1028417,146777,455228,760806,876622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002851s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]