SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524414 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524414 [ RunTime:0.003325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020018,822483,756566,159173,1038203,939284,768556,609834,1031189,89511,52898,1005879,210004,549687,950093,1021386,33298,675574,201390,1018776,81597,942977,613272,576353,64056,782552,380544,315000,48164,527913,109468,770186,53232,670013,781498,168567,654462,937213,580146,640584,255138,576738,206948,427432,646914,111977,34121,697207,212624,676828,65131,578849,487189,989002,801801,73765,727356,854230,547811,930660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003928s ]