SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52016 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52016 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509297,878408,648570,737197,144173,358700,551317,139022,355507,396648,804480,152609,517026,390558,574702,475262,186630,674123,323213,599883,528923,448442,1028853,1031817,110108,601130,589348,448170,4064,398759,312857,94182,604295,2689,232776,935586,894087,794202,679386,906454,101145,427975,444577,134462,870556,904377,28106,943280,101927,508234,966750,653708,247589,1003690,181389,598968,792627,294898,339384,235631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]