SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010393 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010393 [ RunTime:0.002095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939116,337559,818884,748843,725302,293211,970964,843836,273091,293633,220415,276045,285533,1042867,390224,765830,1040688,1001190,591545,824156,978115,76596,504024,507612,133799,915870,846217,655657,897758,951221,9078,676846,604890,835146,792504,453077,299444,939438,980781,163553,859039,293199,599457,1001102,790877,791910,200413,269880,444986,994640,247853,434365,444350,651257,823243,714131,35884,868069,932825,950460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]