SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502077 LIMIT 1 [ RunTime:0.000521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502077 [ RunTime:0.003115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025081,317947,276748,278868,750653,411243,62993,148623,135303,945023,952208,127149,283412,351924,161540,14400,530989,1031881,295830,93623,551995,278654,167431,882662,285080,488294,339859,602861,23041,614304,320214,126933,736298,129402,815566,458330,503247,869324,625459,830279,5189,274656,194523,414708,571168,1023541,78798,324961,716497,698628,559911,336990,792663,494450,737589,660996,780288,759198,457039,782984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502077 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502077 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001429s ]