SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423912 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423912 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343977,583340,1007259,653722,888513,564893,300971,769953,168145,79810,833746,804402,136731,784462,754892,557807,44142,403231,577603,772645,1034288,1974,105700,442695,745501,768068,971175,177388,945990,308564,579248,924566,335438,503590,638864,110158,728525,304060,181022,156394,464964,716146,8728,163350,363471,827709,704336,870296,787224,877846,220384,798572,537218,288699,145733,939115,503069,982812,86208,74637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]