SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001583s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103712 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103712 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593703,737966,820834,1058,971870,84814,1024572,538486,895361,218164,496466,348945,779544,134096,214399,706719,1001901,843739,789922,546953,393293,842710,520692,399148,181418,28290,206933,362685,527597,525926,1039566,373933,314178,948460,603107,1016647,404642,780352,181268,607035,456250,941125,642164,163379,291231,731599,65980,129444,12924,393221,138631,662325,959534,838941,1008479,899084,622471,553272,707115,145596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]