SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001750s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425160 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425160 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974610,413155,653449,630692,838157,776729,536742,825575,280326,643670,203290,889873,447346,357242,564429,1043148,1019637,376172,37838,386085,243256,637988,1013958,299686,410320,101565,224218,534002,538505,192730,690089,869366,12794,307343,374763,1012280,731526,273600,45054,447984,203454,891954,1023078,717547,699609,909346,893644,902774,310062,147133,453943,755729,737820,408460,151723,608679,169907,1001720,166740,636631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]