SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512929 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512929 [ RunTime:0.002662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132911,760005,24597,115687,619157,66537,547164,542827,642700,465177,874022,834021,423818,321720,241672,212783,317973,736362,130349,770098,164109,364715,289784,358081,206520,213529,920922,596534,852359,70541,737124,323131,46933,410241,243121,982899,754990,334975,743583,159317,109963,986434,620880,900840,905335,849409,534880,233344,428281,51011,1005065,371467,865563,881860,530046,696419,900767,110671,305856,396728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]