SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542902 LIMIT 1 [ RunTime:0.000595s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542902 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423678,243389,860382,349672,591168,1035980,230475,194514,723316,732301,326489,317157,1027740,483900,543785,213218,924080,821333,273154,567038,725251,347202,759272,620444,752378,953280,189795,360448,429493,165432,485246,777255,476378,261745,981957,673835,943512,347276,133953,269740,126305,816345,674554,286186,347584,1003414,451578,662512,358547,874799,1025713,249114,875326,944920,305731,533107,457553,424852,707479,648037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]