SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534160 LIMIT 1 [ RunTime:0.000566s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534160 [ RunTime:0.002603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330507,767576,30757,384481,998744,958643,837234,179143,677406,864383,635326,561546,33284,572941,646516,427065,415261,899159,642165,622037,808707,996268,179394,578424,300507,12331,886905,174893,739389,214726,648439,152942,486646,496346,802792,141865,504604,165808,989432,609305,429857,429878,853741,552387,851921,18797,931129,55622,885720,971577,534173,24461,853658,996565,801806,831759,797562,34375,113908,510769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]