SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501838 LIMIT 1 [ RunTime:0.001296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501838 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60679,1010035,101668,431447,812724,27933,561528,1000807,30433,640234,260665,689327,318910,330981,441129,718456,537138,33480,265150,842067,100087,1038461,114851,828192,243508,823138,716378,995297,302506,551960,901687,630436,925767,928554,589181,16705,128537,269239,1023946,17800,133598,994252,284933,332279,63222,833108,484963,677233,992765,589544,201981,337504,75849,562238,61290,551342,20463,718185,235064,391595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002326s ]