SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026098 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026098 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46605,253918,878510,927361,762595,136699,968243,894965,733738,727017,35249,185623,354005,306241,765607,673619,231992,336464,1014347,112731,959945,515292,348129,636620,737559,917729,51474,235744,321860,639024,606141,710193,208413,634619,537928,764981,821916,918280,220499,902728,415944,152951,773385,621077,57055,947352,114452,631553,959843,547857,148526,427833,475843,641231,834930,352570,111121,361395,519072,225485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003537s ]