SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104775 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104775 [ RunTime:0.004888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257699,453436,950134,489410,577259,141733,952803,268039,600390,150301,924058,569050,728545,541481,474104,112899,851800,670212,1016076,888879,598418,255828,381121,13715,580692,1036233,56052,531734,872772,415398,200156,1025203,135245,737105,519077,347850,480383,866671,659754,653719,324325,571907,138785,651001,166195,51491,434299,752051,494270,1014472,781613,133472,327618,659430,801474,388304,990567,17844,96348,453349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104775 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104775 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]