SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205644 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205644 [ RunTime:0.002601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198091,361768,536779,136648,523637,430950,189441,674677,668426,166254,382821,141845,760411,361068,228842,509390,784982,512530,879395,429162,640707,121211,1006401,504742,410815,511669,827951,344133,680046,561565,679363,733658,1043042,907047,549297,1001713,30886,397503,692283,763319,408254,240691,204727,396459,644257,130876,23840,665303,729317,748046,861490,959766,676144,695043,181915,830255,255523,837435,58203,207722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]