SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506088 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506088 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816912,74596,298108,112987,1027553,692845,343010,596836,999688,76501,19666,804460,100852,967718,216505,189875,847673,677341,415867,977944,24191,209408,820450,939533,225875,561793,632524,86141,178802,140721,671662,795135,11578,429061,527771,381573,81269,504621,986708,909759,490740,698906,203068,704884,275233,999139,57402,139670,432865,716077,669098,319076,299997,730848,549951,333657,828990,727803,406991,297592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]