SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020405 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020405 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200106,575446,576175,354782,876925,898928,739578,206369,114903,412411,737300,382893,960671,871972,539034,408838,19066,1014237,255203,362974,919298,371830,161324,361198,946749,17203,831096,93108,867929,920289,611421,1024098,429013,1864,492179,753483,671286,504095,877927,307594,262183,441156,909210,773083,444589,1036446,840858,524160,345142,234061,867207,376371,296708,489399,873878,267037,717957,203164,845735,658633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]