SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556991 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556991 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235494,478364,740343,888417,107510,727505,916709,864135,175065,698224,923557,83830,892208,409609,760509,159199,233380,150860,397793,635287,815262,159644,177767,608747,200920,1045734,689460,598691,930628,743131,576469,334910,110242,874486,30525,553987,653865,755472,739055,707873,1019731,177022,233715,319796,515006,163171,923875,346793,195636,137102,298916,112023,238522,1034751,203522,177308,487708,945129,816685,820054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001006s ]