SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340030 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340030 [ RunTime:0.004834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61115,239082,649114,944814,115042,466912,671631,511678,877083,90052,829640,907374,743335,426760,927075,478129,57740,441609,672791,522097,669651,691658,807604,457190,863214,856517,1046813,633036,148759,657004,853340,883241,555367,730122,271419,230584,1245,489995,221880,38271,932838,989145,667608,917303,321225,403961,70174,587836,583135,258101,383756,155086,208398,1033785,145758,326882,956890,146940,829826,572228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001695s ]