SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540012 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540012 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045331,1038418,620234,172433,779194,126922,301420,804036,675908,293814,833695,825537,589960,1031937,1043824,706006,947810,635292,39989,130798,543436,644341,849353,316124,267145,601488,763574,141437,823622,138565,612139,495213,813442,438252,1017448,412440,305077,235378,44840,707846,805356,512337,93069,867716,841610,861309,119974,638014,24561,292381,51685,934804,819032,291312,991740,1010389,640010,473282,307831,469011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]