SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283718 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283718 [ RunTime:0.002479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820890,90422,285941,833124,884943,1032308,179355,562146,999921,953247,715761,109505,302716,217865,779534,730127,175737,860195,364583,290953,966987,520078,605712,595254,58206,102795,693157,139693,988704,686497,314182,283546,515619,208169,964803,602624,964459,933656,418906,543540,446470,1038814,1001974,895014,484593,896018,228500,1025764,64080,871076,505760,351850,231658,676728,695856,648670,660516,222641,581236,299609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]