SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042898 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042898 [ RunTime:0.003682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390905,636887,901591,760979,938961,326422,169327,640345,699351,659107,760413,731234,763709,273914,568770,689752,139919,503812,450008,1016808,486844,52747,643143,334402,813198,912565,99836,432033,604829,516077,343094,1027774,603312,773912,375050,575888,257741,528051,471902,126333,586355,196882,181401,901458,151026,583291,342288,631133,772752,190578,315365,127502,1018967,456071,969673,726286,532800,982362,845187,300410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]