SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341512 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341512 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803663,797615,628000,1040366,210594,685281,274257,734835,486522,5172,343756,428262,560114,160077,119243,267343,792187,903516,412499,500852,12105,760485,689993,887748,15971,121806,248343,274060,263505,828046,261909,799172,166637,106525,359824,512323,747361,509387,549682,22078,257078,288439,93766,483296,545212,1022549,462842,67602,124440,692844,532632,558568,324550,882630,1048029,50479,750611,584442,10949,1027844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000983s ]