SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103964 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103964 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736719,584669,768383,628873,32300,346251,136037,908346,734051,1029578,382248,769268,203783,980652,455139,1033513,153882,633067,78442,796502,611429,408807,364609,95090,255853,855640,136943,302204,583490,255172,212065,439824,77336,810973,743765,134856,652946,473796,109971,359023,865902,343716,511528,151550,885074,536590,892756,638974,664672,280521,671030,546755,508930,457127,871934,644867,943497,1028966,493337,885043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]