SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405826 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405826 [ RunTime:0.002030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000511,465679,639251,966322,846026,665732,466633,1021734,344390,400695,878646,703421,180793,864396,487886,636263,989474,652200,194677,418124,180302,558964,973701,940114,1034495,953281,1046482,735336,246666,332012,386449,481182,445861,572647,1043466,563905,99099,1026299,963728,411500,495225,1033530,67739,764781,1033251,817285,929601,591081,230884,50304,287104,156371,1040089,417275,504370,149591,225651,990872,565198,632407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]