SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411088 LIMIT 1 [ RunTime:0.001000s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411088 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250578,465836,887223,832676,753004,303238,215116,702578,340806,119276,486338,956805,219941,316898,258629,371600,949044,721945,98131,62362,86674,310332,581203,42493,903721,702652,847565,158113,970418,566089,455734,117212,724702,953251,1036930,392965,1040765,391057,695510,319419,182062,454526,127952,713380,226782,628878,878062,925383,180531,297661,782360,718362,469775,891027,606784,350422,403450,357102,75402,153497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]