SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311875 LIMIT 1 [ RunTime:0.002258s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311875 [ RunTime:0.002588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759462,11697,111578,901027,794794,1019075,80871,731410,983155,67534,176366,1013730,725323,916821,271849,17226,122091,26567,319526,765650,368953,14162,699637,840767,313483,785321,850978,1039441,32898,18966,921161,915761,971740,323029,853002,548353,828902,33011,678693,127879,3267,614043,921936,757137,834519,25714,611710,533688,808028,298270,314177,458194,888824,265855,411544,483807,909575,208466,503463,239220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002418s ]