SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542753 LIMIT 1 [ RunTime:0.000976s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542753 [ RunTime:0.002977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513199,638000,145442,1004488,627811,194732,797398,440356,784032,630805,825541,809091,741832,399917,310081,958711,79939,459684,491888,716472,923788,250316,215368,133398,283104,898049,960713,339170,713247,596234,345668,643267,716432,379004,333379,1024952,751286,952447,1025584,999291,883915,50626,173189,680277,839595,944210,904605,239272,634220,227993,70118,783544,824430,815060,768416,988923,774463,118216,176246,791088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]