SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514100 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514100 [ RunTime:0.006309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919682,161960,704350,531095,570308,441275,223953,715270,66409,884463,598847,296257,630628,379138,730685,474561,1845,890165,706283,637991,537538,106752,995765,691592,131119,271104,485733,268476,457998,118610,276913,119422,440737,712358,744534,414519,180563,5654,46577,1016047,769199,424462,535090,833072,600655,763146,718064,412200,931704,265305,529181,870168,699514,1035253,1030450,32585,900755,302467,910815,1041924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]