SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403351 LIMIT 1 [ RunTime:0.000669s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403351 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710428,157309,118832,769544,610330,292460,441452,420270,366004,741574,823878,781589,941772,814183,850504,425888,444237,663727,640578,1010975,247754,687960,421515,83884,643669,1000219,348590,64161,32826,769578,365116,539155,279413,305762,769800,715033,732842,703583,734779,218466,893884,240053,269286,772459,616923,607565,493799,153370,673812,176869,759997,1005718,222243,267308,449677,78952,894006,702894,995144,356207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]