SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42138 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42138 [ RunTime:0.002833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343848,639668,313422,59269,883599,183454,485219,943044,755999,416024,767985,378528,61701,715588,1018168,115811,426619,933748,392943,507149,172389,1026729,893068,658210,491942,312665,459959,303346,680986,560600,19389,913766,679060,76620,626059,817285,559757,652453,689710,675069,723621,418149,481699,1009370,813919,103785,789737,761752,936068,282370,265357,215219,789573,794304,75674,885582,730818,675603,218906,843504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]