SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39423 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39423 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278231,200992,373350,629198,204384,390994,840639,811489,986168,755004,267370,50561,593105,838805,1019806,600071,290682,362691,209496,788026,68050,661493,461102,757355,388800,917210,723713,572683,1040889,624044,214443,949256,701793,534742,298801,98871,44345,669119,577402,839138,60033,278720,616236,150847,837744,139948,115267,900141,986075,505070,338514,982888,154234,1018235,602005,788362,513829,1017702,373598,900578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001508s ]