SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295209 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295209 [ RunTime:0.002204s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509957,660458,189373,788434,127502,741221,233058,545937,795636,852186,153283,843876,396704,310798,442482,376526,899064,84811,703311,29642,344282,519368,586729,901362,976735,573457,627238,766497,158179,133535,459874,303320,902575,584652,299079,807416,758252,894589,514132,88096,28847,987030,1001660,246615,333678,685778,671671,119728,590992,741489,435504,495224,367878,256091,47542,451425,705552,214482,68395,196830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]