SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401317 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401317 [ RunTime:0.002243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987247,1031466,605361,292034,271734,322843,48534,4334,864228,348076,560676,841662,726458,1024210,435578,648607,826486,821310,104233,305829,231173,767410,465209,338403,1007197,641984,366296,142677,926760,544669,319335,686538,503505,349153,426939,35450,133315,268393,639295,557648,667053,947066,250245,701615,842585,943078,227730,129182,658039,905428,523108,22471,985310,371120,207670,491651,86090,385026,612484,75682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]