SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417525 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417525 [ RunTime:0.002874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414400,49655,23265,406176,28405,1003120,704733,721269,793830,393346,554331,271617,215867,466220,610274,854570,811791,117956,702657,957942,565520,812517,6943,349923,12388,51274,133743,868135,947970,249177,80164,704206,242219,228873,584939,51285,303763,850029,140960,175531,834423,143387,841298,814409,345134,654103,276583,378194,608691,502082,574438,870936,401989,265175,100280,817432,36124,454271,307626,800040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]