SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553836 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553836 [ RunTime:0.002648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603304,30129,178015,184664,916202,574738,1044181,659473,404839,110559,912843,29506,184091,642379,3850,94525,498788,683874,459795,815395,325833,150210,963183,235281,460790,845749,748291,906703,475469,518657,438865,699650,594122,681681,368101,276145,978517,556976,36743,487140,367741,784734,975412,757338,365614,655112,641634,737247,748015,248941,328699,473952,253776,614916,19450,908150,735345,143244,268856,299615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]