SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 73151 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 73151 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932289,257288,909999,1039573,246798,803512,1040820,417566,795406,778150,520489,34161,448054,579711,149927,142534,45341,752373,447679,268298,989257,754068,752676,759316,151298,878475,46912,67230,818659,795322,723283,752953,846632,747680,191164,672881,676761,895597,151971,496555,444013,367688,789929,1001569,871517,718488,457263,289594,702757,218144,388721,44817,64824,496117,379862,728550,139708,173624,248489,174142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 73151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 73151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]