SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436043 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436043 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813814,771810,673602,970963,32747,50680,1006203,387110,125244,800812,944159,1028740,958479,674579,630417,852891,1038629,109374,948425,35220,571777,382208,1038923,56530,814998,34291,265091,288640,771952,87560,256794,66887,123706,310808,306155,515218,185521,471071,450950,773644,51411,34560,706570,871983,266262,909216,479094,32043,892935,470092,244484,675839,555810,557640,736345,1023972,990697,875866,514471,225893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]