SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034067 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034067 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123531,367014,196628,830807,147221,541323,568844,671749,599852,1030337,1030648,430193,110190,166703,1039348,906741,892912,971401,200964,940732,529306,469550,357602,588443,352242,373269,980521,957409,992171,510314,1037568,487312,614207,105196,476884,343804,650592,856236,134508,924561,555360,868809,159601,1041528,225003,694451,754714,347715,406781,754751,606181,564689,333326,22153,102351,399367,371618,547271,768304,201174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]