SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531399 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531399 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624484,717134,275451,740203,95467,790909,695851,120166,409026,231534,823099,854205,460686,914174,391474,167051,1045816,132879,507796,776184,927566,301029,1019982,624745,933540,624463,245957,310033,531309,753142,953697,540728,408561,352044,814370,787007,274883,1010635,405401,843959,207930,201786,246759,990568,944462,431682,547192,777974,591390,1010126,321682,376380,1007284,426290,749457,272519,61634,525739,978131,634663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]