SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490217 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490217 [ RunTime:0.004990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40385,476246,436000,754593,762030,549687,684300,691119,695208,404684,44419,893609,959857,1028232,601045,984493,709305,753818,39892,1033940,67418,49723,336651,867306,7345,604578,110959,453604,122331,1037887,309064,114525,677026,118127,757941,816521,526592,440857,901349,77000,191989,498141,458684,878477,737258,347039,53502,732172,270444,655567,13244,211017,693166,130268,815402,110690,18768,783509,230209,558885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]