SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318806 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318806 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464306,1039782,1041963,983291,784680,531965,24639,929623,233125,20578,624424,754933,357789,200873,362914,197636,542418,50622,9979,446842,655775,410545,790828,497453,831755,344919,619874,926716,341533,178848,106157,403195,707460,547144,632819,66220,268343,562243,837934,872445,923594,458280,585993,745073,370752,468650,816749,345228,8197,799730,608962,844214,104176,541465,735996,848282,967427,310913,936076,584270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]