SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020014 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020014 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517929,459092,739328,628277,305259,51070,179306,736381,566559,316030,888114,696349,374331,520120,421658,337038,587392,392366,342415,120653,929317,106478,386454,396886,461711,350542,743109,965321,526172,1029916,27386,555763,170395,863453,233526,232082,476183,214495,38978,700464,499071,553173,284971,308144,270764,658624,1044392,1005774,287916,42566,850496,279008,206221,226401,254092,435413,355513,155855,8359,272140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]