SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499654 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499654 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35257,781724,361918,8389,548367,234402,490924,263115,999365,146023,809852,907763,303569,157378,640675,813899,427272,132302,58647,55526,678685,192050,129115,751921,950402,833803,52577,906671,580788,40044,610780,391440,77349,563423,435593,539852,946799,20081,529536,754140,819183,621650,510699,98492,911583,307002,354218,532969,572768,858714,329698,641997,267051,85326,136027,722405,584766,765274,65252,276071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001883s ]