SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483245 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483245 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52547,78068,633216,1011230,143169,403812,520956,318596,390666,182837,647205,593906,33380,877749,364562,783931,338290,855381,609110,390014,258399,456797,693480,1041365,860736,658716,847809,788568,338552,684829,439831,466124,777320,194809,310728,237520,360430,197447,458060,985754,913727,876322,546843,320354,868825,252067,965273,444483,571022,597712,83920,56526,920812,155065,904252,703943,390143,185587,505972,861554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001189s ]