SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029889 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029889 [ RunTime:0.002970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305940,269733,184580,803349,54706,565670,53732,392018,406781,761853,522865,186128,365465,39743,140789,425116,199855,292436,700120,599204,849901,393665,659997,69330,738133,205211,94853,718288,731232,383822,664243,869473,19277,376463,763693,711053,796451,378178,723810,829345,851652,651483,618898,862708,953723,613224,778516,779832,466148,184514,756629,648630,395852,503469,293327,686482,389515,881763,500960,656571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]