SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503618 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503618 [ RunTime:0.001417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978765,253697,239068,714540,653273,839985,562299,199246,596650,240110,695687,470565,280909,1026752,360718,729025,779680,984800,796669,95527,363476,372376,152757,130571,1005153,128034,875490,730960,371364,577801,634271,354807,546834,472719,902522,594615,207489,1046624,51501,1047101,709258,119251,855608,902293,937307,434059,999429,1044000,270015,579009,212089,189168,694617,621605,82278,298677,49762,353447,345182,585465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]