SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 916040 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 916040 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424244,719904,755211,1000021,273051,748350,102537,325379,446435,764898,524505,108518,642190,24979,106680,663325,780003,244418,795695,794873,787691,303514,635210,228701,965442,757133,476270,66046,943438,768571,67789,340508,131396,709361,797117,272402,352671,742500,654719,596639,181896,675637,1008043,443790,421371,439803,273570,417774,312253,394742,377778,981630,718506,874403,964765,462288,953333,56298,101871,383937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 916040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 916040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]