SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552540 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552540 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447548,634897,104406,818961,913160,579693,940094,910592,688102,284354,529414,889329,34025,818719,16914,187553,187936,66245,872559,335938,509308,154902,510733,326351,810895,183261,644191,1022631,377935,806720,451236,583435,522334,215040,794663,892082,200901,941828,201289,322947,189798,106597,460767,939172,579245,939159,670750,363820,956974,483700,746004,454878,714968,750100,718588,373644,374267,184075,152982,873919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]