SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109758 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109758 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116912,79180,199287,130061,630201,14745,100530,609733,314361,636026,642445,165407,685877,1017539,255666,403880,132308,1045308,6582,239310,814589,468399,99321,565588,393052,195400,16722,816867,235545,345066,304634,149903,386071,250692,376822,988606,648195,419416,565028,577363,1041386,478094,602215,26725,122914,292026,958960,702238,118039,364041,338146,92358,1038554,734440,210095,149814,551921,216027,875500,554245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109758 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109758 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]