SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266819 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266819 [ RunTime:0.003361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007916,147207,302692,229001,550453,109505,922789,159373,146202,485969,164195,783651,946411,243494,72616,405316,1032369,500596,87841,747726,1006185,851446,919502,7011,535151,240156,430565,81737,2352,201416,826838,1026079,1021561,466052,785583,922173,446602,572590,962608,52567,689096,265788,491448,821594,758230,48691,413836,628423,907615,137869,640300,467826,793940,372195,596641,760288,1032718,595927,488227,890010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]