SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562201 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562201 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858928,251181,311384,935586,975439,974316,795874,137659,169696,486674,847748,323567,133989,467279,810615,512452,867714,638825,293795,392101,886177,923426,699231,584026,514370,480237,172846,212602,263176,67980,69911,905897,756786,89782,594401,132493,777115,956368,740502,802768,40619,986439,730051,78032,113502,78835,767118,82127,190596,299061,1042011,271844,831211,969930,805332,933259,435704,256000,496699,29391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]