SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412591 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412591 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333566,58467,608625,943804,1002939,1010093,665509,711845,912653,608592,766932,392370,937584,934283,60341,59449,699230,112032,52607,212497,226788,1010467,415774,906843,669916,419901,189589,899718,748323,139852,215173,766551,377686,440494,132870,943612,29162,750384,443924,376117,214892,617974,885728,983725,700501,841805,78136,693802,25198,47855,977110,438107,828903,780214,69588,364290,144395,218489,666582,477857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]