SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001676s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495508 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495508 [ RunTime:0.002439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696051,320156,461964,980769,536992,679090,193062,325182,367718,721894,283942,250729,678365,840853,93418,271428,69614,877762,549231,154886,901846,376663,833938,25633,405005,234225,975940,350014,375196,325922,777176,243751,887522,927701,333195,885578,40621,978758,425537,390768,509691,808064,287802,294038,204396,887432,286272,558034,823860,519833,302757,433658,599121,200228,1041345,216774,420511,689362,1608,178614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]