SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433438 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433438 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931398,738108,90112,36011,300628,177765,664824,765124,103546,640440,273479,402641,47433,511773,21894,363552,898057,672456,339464,868661,908304,551042,396338,250907,483177,575700,992478,687835,481952,802839,326058,652401,478208,66652,1036329,551188,539421,292006,963198,444965,593664,388383,743953,291850,718650,95457,1031860,1040073,437053,206919,384440,243824,273231,724971,882567,1022470,538407,1029382,360594,84591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]