SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510956 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510956 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221250,635412,1034845,638129,883267,844001,756548,790912,433033,261012,397593,758346,489662,121100,658373,318520,1029855,629986,15546,89134,390241,965474,812472,978099,9268,840349,322012,18008,164877,673063,85058,1019724,762317,827965,911016,73440,7354,801986,711544,901534,702364,506835,490450,281360,1013227,865722,32027,1003142,815935,106663,532275,311366,37761,575731,310014,537816,1028537,159997,213075,122275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]