SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438087 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438087 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23330,1034455,634708,974781,11870,165865,718235,483613,191347,30681,554847,724747,743871,688892,267035,864827,625764,348297,927870,215126,417528,856540,601841,621551,295762,683541,186517,26310,178312,932332,258667,105250,318316,691014,354225,371439,748757,486177,893635,231014,917716,319778,971839,898235,191328,14625,768619,924234,868601,53281,977284,709160,653203,685581,674601,520093,92119,98719,817270,1027005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]