SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541291 LIMIT 1 [ RunTime:0.004595s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541291 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810731,879014,627774,179545,390073,826424,197406,67036,308562,578496,783918,987236,693733,246233,582870,334946,331333,970598,224048,814543,151732,212806,268409,164711,541052,525307,938296,77594,788288,913361,111204,794891,73494,247990,928523,183180,865841,185739,849466,504432,402161,960190,687310,395306,577583,449998,823732,98115,44070,628901,446533,35248,934137,894857,437859,847828,99068,672307,898611,169078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]