SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006750s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510968 LIMIT 1 [ RunTime:0.002211s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510968 [ RunTime:0.002244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160917,939043,326496,405064,546433,941754,492000,17220,510055,738571,34190,52157,682776,126210,1014036,999915,738306,16174,510786,520950,735443,981981,802067,216346,275914,511989,174464,382228,185327,851170,76628,167586,548426,962426,763776,269244,484268,484231,429229,511419,832988,971662,940093,88437,960744,343906,907905,446535,807255,709802,985037,714705,207897,926882,697801,687980,899137,299100,219173,1922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]