SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981458 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981458 [ RunTime:0.004412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323012,471522,235566,783568,886753,271526,503438,675697,922550,210473,323544,320978,750180,667624,233482,874336,731761,154408,949236,994362,376476,341234,694868,528882,296249,1022426,229173,260812,864966,646219,41021,528567,876803,1016265,664903,325894,586558,896482,743285,121200,820847,1037203,16487,49296,105201,752535,892651,956684,498186,659427,893179,216387,779898,611723,7270,828112,145461,883130,521166,337389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]