SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 388018 LIMIT 1 [ RunTime:0.002120s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388018 [ RunTime:0.003412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718748,936350,588421,621208,546670,530207,281507,74640,313193,519219,500979,991982,591393,838732,129141,382507,692989,87842,1032949,307585,272777,11249,873932,47957,1000475,822131,759697,11300,135156,759898,775438,236380,445601,440118,813674,159816,1014443,690015,701733,139808,657287,619257,1006030,633793,525522,473123,913391,939322,877335,210222,814416,287758,482684,373083,945436,995392,962195,353348,616326,805287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003974s ]