SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001932s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566973 LIMIT 1 [ RunTime:0.000713s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566973 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427129,608358,707866,268743,898725,420629,396347,716549,262977,151838,230005,231444,55739,357367,315877,416329,390548,354224,377541,871372,499289,61745,261199,3488,369513,326117,819319,314809,488960,405845,956020,659651,182939,237313,543418,66776,489065,923590,916269,1023168,491959,457635,237839,303112,474530,1037810,953983,606695,516320,905294,855885,1043363,982212,932372,260831,751284,569343,505591,209971,849599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566973 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566973 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]