SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534803 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534803 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779721,425464,272865,201432,746030,392883,121276,639660,494228,704431,5622,181636,238074,440751,326577,164456,739939,429348,584898,1481,642303,713086,864858,959072,1046712,298625,44243,602514,269752,204949,968572,579285,276898,491022,570515,546295,559013,746367,432911,856380,346552,788790,329106,857831,917881,154297,806211,792513,600516,936759,630576,835699,628145,952611,538270,949770,502371,457783,677411,850578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]