SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479303 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479303 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55359,738296,528904,147493,80556,179980,802844,543599,96715,782877,526554,1033841,773041,601535,223707,405175,473731,185000,395585,582557,1035990,628290,661102,360608,357712,986368,370638,529460,21536,532301,40884,641341,804471,545780,905720,287607,503305,179325,474804,968771,920946,713508,783642,1026091,152146,425367,476039,509737,879778,274573,548666,98674,782718,623582,629450,940751,73766,226746,614592,681247) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002175s ]