SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201560 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201560 [ RunTime:0.005367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885545,384734,136209,536430,980842,561936,625531,981864,292514,723309,148217,306916,29624,366567,466463,467475,1027844,478627,893729,123298,225992,199034,57613,749921,29056,468688,494177,568546,308945,145264,804858,996604,368096,308680,281778,987269,404166,186370,399697,642140,968919,409340,402723,1030522,92134,103835,815468,619301,724586,816947,830730,18247,130041,661175,321322,428877,508871,817394,102885,575032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]