SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108198 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108198 [ RunTime:0.002968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656076,589166,124818,538647,359693,910958,614124,94898,340127,755626,582355,767360,611452,235679,9449,389549,842398,437906,456815,478340,236917,980325,357010,676180,116973,566865,501773,500764,911042,746604,252519,351243,1000624,814154,698319,362735,1035631,871957,789858,220286,906273,911691,711321,663829,374110,809711,389073,992113,350370,632064,572234,997172,365240,856659,752904,46728,449444,1004804,746321,450423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]